﻿CREATE TABLE [dbo].[Bank] (
    [BankId] UNIQUEIDENTIFIER NOT NULL DEFAULT newid(),
    [Name] VARCHAR(256) NOT NULL, 
    [Branch] VARCHAR(256) NULL,  
    [SwiftCode] VARCHAR(11) NOT NULL, /* can be 8 or 11 */
    [RoutingTransitNumber] CHAR(9) NOT NULL, /* always 9 */
    CONSTRAINT [PK_Bank] PRIMARY KEY CLUSTERED ([BankId] ASC)
);

